package com.example.practice2023.mapper;

import com.example.practice2023.pojo.User;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * ClassName: UserMapper
 * Package: com.example.practice2023.mapper
 * Description:
 *
 * @Author hyx
 * @Create 2023/7/3 0:16
 * @Version 1.0
 */
public interface UserMapper {
//    User selectByUserName(@Param("username") String username);

    List<User> selectByPage(@Param("index") Integer index,
                            @Param("limit") Integer limit,
                            @Param("username") String username,
                            @Param("type") String type,
                            @Param("phone") String phone,
                            @Param("status") Integer status);


    int selectAllCount(@Param("username") String username,
                       @Param("type") String type,
                       @Param("phone") String phone,
                       @Param("status") Integer status);

    void insertStaff(User user);


    void updateStaff(User user);

    void deleteStaff(Integer id);
}
